<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersExtendTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users_extend', function (Blueprint $table) {
            $table->increments('id');
            $table->string('consult_types')->default('')->comment('咨询方式');
            $table->decimal('text_price')->default('0.00')->comment('文字咨询价');
            $table->decimal('voice_price')->comment('语音咨询价');
            $table->string('take_order_day_begin')->default('')->comment('接单开始日期');
            $table->string('take_order_day_end')->default('')->comment('接单截止日期');
            $table->string('time_limits')->nullable()->comment('接单时间段');
            $table->tinyInteger('is_take_order')->default('0')->comment('是否接单');
            $table->string('skill_ids')->nullable()->comment('擅长领域');
            $table->string('therapy_ids')->nullable()->comment('擅长疗法');
            $table->string('listen_ids')->nullable()->comment('倾听风格');
            $table->string('intro')->nullable()->comment('个人介绍');
            $table->string('technical')->default('')->comment('职称');
            $table->string('education')->default('')->comment('学历');
            $table->string('age_limit')->default('')->comment('年限');
            $table->string('professional')->default('')->comment('资质');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('users_extend');
    }
}
